USE AdventureWorks
GO

CREATE PROCEDURE [dbo].[spLongRunning]
AS

WAITFOR DELAY '00:00:01'
PRINT '25'
-- RAISERROR ('25', 1, 1)
-- RAISERROR ('25', 10, 1) WITH NOWAIT

WAITFOR DELAY '00:00:01'
PRINT '50'
--RAISERROR ('50', 10, 1) WITH NOWAIT

WAITFOR DELAY '00:00:01'
PRINT '75'
--RAISERROR ('75', 10, 1) WITH NOWAIT

WAITFOR DELAY '00:00:01'
PRINT '100'
--RAISERROR ('100', 10, 1) WITH NOWAIT
